CREATE TABLE [dbo].[CertificationProgramRegistrationCertificationModule]
(
[CertificationProgramRegistrationKey] [uniqueidentifier] NOT NULL,
[CertificationModuleKey] [uniqueidentifier] NOT NULL,
[CertificationProgramRegistrationCertificationModuleKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_CertificationProgramRegistrationCertificationModule_CertificationProgramRegistrationCertificationModuleKey] DEFAULT (newid())
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[CertificationProgramRegistrationCertificationModule] ADD CONSTRAINT [PK_CertificationProgramRegistrationCertificationModule] PRIMARY KEY CLUSTERED ([CertificationProgramRegistrationCertificationModuleKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationProgramRegistrationCertificationModule_CertificationModuleKey] ON [dbo].[CertificationProgramRegistrationCertificationModule] ([CertificationModuleKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationProgramRegistrationCertificationModule_CertificationProgramRegistrationKey] ON [dbo].[CertificationProgramRegistrationCertificationModule] ([CertificationProgramRegistrationKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CertificationProgramRegistrationCertificationModule] ADD CONSTRAINT [FK_CertificationProgramRegistrationCertificationModule_CertificationModule] FOREIGN KEY ([CertificationModuleKey]) REFERENCES [dbo].[CertificationModule] ([CertificationModuleKey])
GO
ALTER TABLE [dbo].[CertificationProgramRegistrationCertificationModule] ADD CONSTRAINT [FK_CertificationProgramRegistrationCertificationModule_CertificationProgramRegistration] FOREIGN KEY ([CertificationProgramRegistrationKey]) REFERENCES [dbo].[CertificationProgramRegistration] ([CertificationProgramRegistrationKey])
GO